Utilizamos esse notebook para criar um arquivo CSV que contém o nome do vereador e o "sequential_id"
O nome do vereador está igual ao site da câmara de vereadores.
Criamos esse arquivo pra poder juntar as informações do perfil do vereador e com as informações disponibilizadas no TSE que são identificadas pelo número sequencial
In [1]:
import pandas as pd
In [14]:
seqs = [
[250000011625, "Abou Anni"],
[250000019125, "Adilson Amadeu"],
[250000004979, "Adriana Ramalho"],
[250000022073, "Alessandro Guedes"],
[250000022074, "Alfredinho"],
[250000004981, "Aline Cardoso"],
[250000008293, "André Santos"],
[250000022075, "Antonio Donato"],
[250000022076, "Arselino Tatto"],
[250000008347, "Atilio Francisco"],
[250000004982, "Aurélio Nomura"],
[250000010990, "Caio Miranda Carneiro"],
[250000010991, "Camilo Cristófaro"],
[250000022114, "Celso Jatene"],
[250000010847, "Claudinho de Souza"],
[250000011011, "Conte Lopes"],
[250000011013, "Dalton Silvano"],
[250000005003, "Daniel Annenberg"],
[250000011016, "David Soares"],
[250000020825, "Edir Sales"],
[250000022081, "Eduardo Suplicy"],
[250000004992, "Eduardo Tuma"],
[250000010992, "Eliseu Gabriel"],
[250000004984, "Fabio Riva"],
[250000011018, "Fernando Holiday"],
[250000020779, "George Hato"],
[250000008375, "Gilberto Nascimento"],
[250000005006, "Gilson Barreto"],
[250000022120, "Isac Felix"],
[250000022084, "Jair Tatto"],
[250000005798, "Janaina Lima"],
[250000004997, "João Jorge"],
[250000020837, "José Police Neto"],
[250000022086, "Juliana Cardoso"],
[250000004989, "Mario Covas Neto"],
[250000058381, "Milton Ferreira"],
[250000011022, "Milton Leite"],
[250000011624, "Natalini"],
[250000022124, "Noemi Nonato"],
[250000010999, "Ota"],
[250000004986, "Patricia Bezerra"],
[250000019126, "Paulo Frange"],
[250000004987, "Prof. Claudio Fonseca"],
[250000004995, "Quito Formiga"],
[250000011622, "Reginaldo Tripoli"],
[250000022098, "Reis"],
[250000020813, "Ricardo Nunes"],
[250000022137, "Ricardo Teixeira"],
[250000008366, "Rinaldi Digilio"],
[250000010857, "Rodrigo Gomes"],
[250000020852, "Rodrigo Goulart"],
[250000020854, "Rute Costa"],
[250000014885, "Sâmia Bomfim"],
[250000011027, "Sandra Tadeu"],
[250000022100, "Senival Moura"],
[250000010842, "Soninha"],
[250000008365, "Souza Santos"],
[250000022111, "Toninho Paiva"],
[250000014868, "Toninho Vespoli"],
[250000010863, "Zé Turin"],
]
In [15]:
len(seqs)
Out[15]:
In [16]:
df = pd.DataFrame(seqs, columns=['sequential_id', 'name'])
In [17]:
df.to_csv("../data/sequential_id.csv", index=False)
In [ ]:
In [ ]: